
--Warning: Execute the StateInsertion.sql prior to this.

--Delete the existing values to avoid conflicts.
DELETE FROM District

--Insert values to District
DBCC CHECKIDENT (District, RESEED, 0)
GO

/*** Dist. of Karnataka **/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Bidar')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Belgaum')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Bijapur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Bagalkot')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Bellary')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Bangalore Rural District')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Bangalore Urban District')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Chamarajnagar')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Chikkodi')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Chikmagalur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Chitradurga')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Davanagere')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Dharwad')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Dakshina Kannada')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Gadag')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Gulbarga')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Hassan')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Haveri District')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Kodagu')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Kolar')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Koppal')
GO
INSERT INTO District(StateId
					,DistrictName)
<<<<<<< .mine
			  VALUES(1
=======
			  VALUES(1
					,'Dakshina Kannada')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Dakshina Kannada')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Dakshina Kannada')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
>>>>>>> .r120
					,'Mandya')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Mysore')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Raichur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Shimoga')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Tumkur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Udupi')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Chikballapur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(1
					,'Yadgir')
GO




















/** Dist. of Andhra Pradesh **/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'	Adilabad')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Anantapur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Chittoor')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'East Godavari')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Guntur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Hyderabad')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'YSR district')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Karimnagar')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Khammam')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Krishna (N T R District)')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Kurnool')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Mahbubnagar')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Medak')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Nalgonda')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Nellore')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'	Nizamabad')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Prakasam')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Rangareddi')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Srikakulam')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Vishakhapatnam')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(2
					,'Vizianagaram')
GO


INSERT INTO District(StateId
					,DistrictName)
<<<<<<< .mine
			  VALUES(2,'Warangal')
=======
			  VALUES(2
					,'Warangal')
>>>>>>> .r120
GO

INSERT INTO District(StateId
					,DistrictName)
<<<<<<< .mine
			  VALUES(2,'West Godavari')
=======
			  VALUES(2
					,'West Godavari')
>>>>>>> .r120
GO
/*** Dst. of Arunachal Pradesh ***/
INSERT INTO District(StateId
					,DistrictName)
<<<<<<< .mine
			  VALUES(3,'	Anjaw')
=======
			  VALUES(3
					,'	Anjaw')
>>>>>>> .r120
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Changlang')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'East Kameng')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'East Siang')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'West Godavari')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Lohit')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Lower Subansiri')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Papum Pare')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Tawang')
GO

INSERT INTO District(StateId
					,DistrictName)
<<<<<<< .mine
			  VALUES(3
					,'Tirap')
=======
			  VALUES(3
					,'	Tirap')
>>>>>>> .r120
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Dibang Valley')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Upper Siang')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'Upper Subansiri')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'West Kameng')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(3
					,'West Siang')
GO
/** dist. of Assam **/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Barpeta')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Bongaigaon')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Cachar')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Darrang')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Dhemaji')
					
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Dhubri')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Dibrugarh')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Goalpara')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Golaghat')
GO
INSERT INTO District(StateId
					,DistrictName)
<<<<<<< .mine
			  VALUES(4
					,'Zailakandi')
=======
			  VALUES(4
					,'Hailakandi')
>>>>>>> .r120
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Jorhat')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Karbi Anglong')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Karimganj')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Kokrajhar')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Lakhimpur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Marigaon')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Nagaon')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Nalbari')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Dima Hasao')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Sibsagar')
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Sonitpur')
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(4
					,'Tinsukia')

GO
/**** Dist. of Bihar ****/

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Araria')
GO					
					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Arwal')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Aurangabad')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Banka')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Begusarai')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Bhagalpur')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Bhojpur')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Buxar')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Darbhanga')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'East Champaran')
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Gaya')
GO							
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Gopalganj')	
GO					
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Jamui')													
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Jehanabad')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Khagaria')	
GO				
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Kishanganj')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Kaimur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Katihar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Lakhisarai')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Madhubani')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Munger')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Madhepura')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Muzaffarpur')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Nalanda')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Nawada')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Patna')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Purnia')																															
GO


INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Rohtas')																															
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Saharsa')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Samastipur')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Sheohar')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Sheikhpura')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Saran')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Sitamarhi')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Supaul')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Siwan')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'Vaishali(Akshay)')																															
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(5
					,'West Champaran')	
GO

/*** District of Chhattisgarh ***/	
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Bastar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Bijapur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Bilaspur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Dantewada')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Dhamtari')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Durg')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Jashpur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Janjgir-Champa')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Korba')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Koriya')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Kanker')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Korba')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Mahasamund')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Narayanpur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Raigarh')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Rajnandgaon')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Raipur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(6
					,'Surajpur')	
GO
/**** District of Delhi ****/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'Central Delhi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'East Delhi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'New Delhi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'North Delhi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'North East Delhi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'North West Delhi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'South Delhi')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'South West Delhi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(7
					,'West Delhi')	
GO

/**** Dist. of GOA ****/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(8
					,'North Goa')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(8
					,'South Goa')	
GO

/**** Dist of Gujarat ****/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Ahmedabad')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Amreli District')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Anand')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Banaskantha')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Bharuch')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Bhavnagar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Dahod')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'The Dangs')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Gandhinagar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Jamnagar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Junagadh')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Kutch')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Kheda')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Mehsana')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Narmada')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Navsari')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Patan')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Panchmahal')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Porbandar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Rajkot')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Sabarkantha')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Surendranagar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Surat')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Vadodara')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(9
					,'Valsad')	
GO
/*** Dist. of Haryana ***/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Ambala')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Bhiwani')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Faridabad')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Fatehabad')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Gurgaon')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Hissar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Jhajjar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Jind')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Karnal')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Kaithal')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Kurukshetra')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Mahendragarh')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Mewat')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Panipat')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Panchkula')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Rewari')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Rohtak')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Sirsa')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Sonepat')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Yamuna Nagar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(10
					,'Palwal')	
GO
/*** Dist. of Himachal Pradesh ***/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Bilaspur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Chamba')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Hamirpur')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Kangra')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Kinnaur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Kulu')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Lahaul and Spiti')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Mandi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Shimla')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Sirmaur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Solan')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(11
					,'Una')	
GO


/*** Dist. of Jammu and Kashmir ***/

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Anantnag')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Badgam')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Bandipore')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Baramula')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Doda')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Ganderbal')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Jammu')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Kargil')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Kathua')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Kishtwar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Kupwara')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Kulgam')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Leh')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Poonch')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Pulwama')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Rajauri')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Ramban')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Reasi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Samba')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Shopian')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Srinagar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(12
					,'Udhampur district')	
GO
/*** Dist. of Jarkand ***/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Bokaro')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Chatra')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Deoghar')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Dhanbad')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Dumka')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'East Singhbhum')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Garhwa')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Giridih')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Godda')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Gumla')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Hazaribag')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Koderma')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Lohardaga')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Pakur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Palamu')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Ranchi')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Sahibganj')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Seraikela-Kharsawan')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'West Singhbhum')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(13
					,'Ramgarh')	
GO

/*** Dist. of Kerela ***/
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Alappuzha')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Ernakulam')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Idukki')	
GO

INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Kollam')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Kannur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Kasaragod')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Kottayam')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Kozhikode')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Malappuram')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Palakkad')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Pathanamthitta')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Thrissur')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Thiruvananthapuram')	
GO
INSERT INTO District(StateId
					,DistrictName)
			  VALUES(14
					,'Wayanad')	
GO

